Hello everyone.
In this lecture we will cover important logical functions.
We begin by discussing the logical test on a single argument.
That is if one particular condition is true or false single argument test can be implemented very easily
by just typing is equal to select all and apply the condition.
In this case we want to identify if any student has good underlying maths or not to type is equal to
select.
Diesel is equal to 100 extend for other cells risky outcome is true for only one student.
If student forward who has scored hundred mats then we have two or more arguments two situations arise.
Either we want to check that all arguments are true or not.
What we want to take if any one or more of the arguments true or not.
If all arguments are to be true we use and statement for example if we want to identify students who
have distinction that is they scored 75 and all the trees object we will use is equal to an
and then do all the three conditions separated by commas
extended we can see that three students are more than 75 marks an auditory subject if you want to check
truthfulness of any one or more of the arguments we use or for example if we want to request to read
to a Palin one or more of this object we use is equal to or an entity.
The argument
we extended we can see that only one of these two student has failed because that student scored 30
in English which is less than 35.
Let's move on to the next formula which is the formula.
This formula uses the outcome of the logical test that we discussed previously and gives predefined
output for true and false outcomes.
For example if you want to assign grades to students basis the math scored less to rent an equal to
or more than 75 marks in math as Grade A else has Grade B.
We do this by typing is equal to if the logical test
output if true
it folds
extended for others four and total
if we want to do multiple logical tests in sequential format we can use nested ifs nested if means that
within one if statement you use an additive statement which will be or visit the output of festive.
It will be easier to understand us using an example if you want to grade students as a if scored is
more than equal to a different b if scored is between 60 and 85 and see if scored is less than 60 at
first.
If will take if it is more than 85.
If you read a Grade A it falls
second it would just administrative reject if it is less than 60 or not.
If it is less than 60 then grade C S grade B
we can further have more ifs if we want to have more checks such as to introduce Grade B.
We can for that have another take of 40 monks tried to do that yourself.
We can also have and are within the if statement if we want to check several conditions at the same
thing.
In the previous year we used and and R Rich was giving a reward for this outcome.
Now using if we can have particular output to these outcomes if true we want to output pass with distinction.
It's nothing so let's apply this formula.
Passed with distinction.
For or we will have if true output will be filled.
Else we will have promoted to next class
to write on the three conditions English less than thirty five signs less than today my maths.
In debate
if pro gay
is promoted to next class standard for.
I just went until the the last student fame has failed all the other poster and I've been promoted to
next class next to him we want to counter function although this is part of statistical formulas in
the formulas menu but we will discuss it with the logical a formula only due to its similarity with
a function on the fraternity count of cells which are this way given great idea here if we want to identify
a number of students who have scored grade A B or C in a very subdued we type is equal to cognitive
then select the range
from major indicated idea
into
extended the Great to
so whenever masquerade matters with a common counted as one.
So we have to rent integrity to it greatly.
And no one would see similar operation can be done on other subjects.
Remember to put a dollar sign appropriately before attending the formula.
You can refer the previous lecture to see how to put dollar signs in the formulas before extending them
if we want to have multiple takes like on thing count.
If it can be used to implement count EPS we tape is equal to count trips for a strange first criteria
then secondary and second criteria.
And so on.
So to get the count of student with distinction we use contests as follows is equal to collectives empire
to M name likely criteria then is in range select the criteria and the total range selected.
And the advantage of using condoms is just by changing the value in this cell say resisted criteria
cell of 75.
We can change the criteria of classification of distinction or not.
We can see that no cell rank has scored more than 90 marks in all its subjects.
However context only gives us the cone.
It does not tell you which to date is actually password distinction which we found out earlier.
Using the if statement make Next up is some formula.
This is also not part of logical formless policy.
It is under mathematical formulas but let's cover this also with a in context some of is similar to
content.
The only difference that it will add these cells which satisfy the great idea instead of just counting
them.
For example if we want to find some of marks of student in maths we have not really restart by typing
is equal to some if
I select the criteria widget field column then specify criteria which is if follows
then specify the range.
Some range.
It is the math score of the student.
This is a return 349 is reserved.
What is some of math scores of students who are party class.
That is the first for student.
Ninety nine point sixty five plus eighty five plus hundred which is 349.
Similarly you can find this for other subjects also also in this table
like we discussed condoms I would encourage you to explode some apps on your own.
No that's all for this lecture in the next lecture.
We will discuss the dating formulas.
Thanks.